Overview

Dataset statistics

Number of variables44
Number of observations1312
Missing cells2970
Missing cells (%)5.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory451.1 KiB
Average record size in memory352.1 B

Variable types

CAT30
NUM14

Reproduction

Analysis started2020-08-17 15:34:11.258040
Analysis finished2020-08-17 15:36:18.890996
Duration2 minutes and 7.63 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Owner has a high cardinality: 305 distinct values High cardinality
Farm.Name has a high cardinality: 550 distinct values High cardinality
Mill has a high cardinality: 441 distinct values High cardinality
ICO.Number has a high cardinality: 842 distinct values High cardinality
Company has a high cardinality: 270 distinct values High cardinality
Altitude has a high cardinality: 384 distinct values High cardinality
Region has a high cardinality: 338 distinct values High cardinality
Producer has a high cardinality: 663 distinct values High cardinality
Number.of.Bags has a high cardinality: 131 distinct values High cardinality
Bag.Weight has a high cardinality: 57 distinct values High cardinality
Grading.Date has a high cardinality: 556 distinct values High cardinality
Owner.1 has a high cardinality: 308 distinct values High cardinality
Total.Cup.Points has a high cardinality: 179 distinct values High cardinality
Expiration has a high cardinality: 554 distinct values High cardinality
altitude_high_meters is highly correlated with altitude_low_meters and 1 other fieldsHigh correlation
altitude_low_meters is highly correlated with altitude_high_meters and 1 other fieldsHigh correlation
altitude_mean_meters is highly correlated with altitude_low_meters and 1 other fieldsHigh correlation
Country.of.Origin is highly correlated with SpeciesHigh correlation
Species is highly correlated with Country.of.Origin and 9 other fieldsHigh correlation
Bag.Weight is highly correlated with SpeciesHigh correlation
In.Country.Partner is highly correlated with Species and 3 other fieldsHigh correlation
Harvest.Year is highly correlated with SpeciesHigh correlation
Variety is highly correlated with SpeciesHigh correlation
Processing.Method is highly correlated with SpeciesHigh correlation
Cupper.Points is highly correlated with SpeciesHigh correlation
Moisture is highly correlated with SpeciesHigh correlation
Category.One.Defects is highly correlated with SpeciesHigh correlation
Quakers is highly correlated with SpeciesHigh correlation
Certification.Body is highly correlated with In.Country.Partner and 2 other fieldsHigh correlation
Certification.Address is highly correlated with In.Country.Partner and 2 other fieldsHigh correlation
Certification.Contact is highly correlated with In.Country.Partner and 2 other fieldsHigh correlation
Farm.Name has 356 (27.1%) missing values Missing
Mill has 310 (23.6%) missing values Missing
ICO.Number has 147 (11.2%) missing values Missing
Company has 210 (16.0%) missing values Missing
Altitude has 223 (17.0%) missing values Missing
Region has 58 (4.4%) missing values Missing
Producer has 231 (17.6%) missing values Missing
Harvest.Year has 49 (3.7%) missing values Missing
Variety has 205 (15.6%) missing values Missing
Processing.Method has 156 (11.9%) missing values Missing
Color has 220 (16.8%) missing values Missing
altitude_low_meters has 231 (17.6%) missing values Missing
altitude_high_meters has 231 (17.6%) missing values Missing
altitude_mean_meters has 231 (17.6%) missing values Missing
Acidity is highly skewed (γ1 = 33.94016411) Skewed
altitude_low_meters is highly skewed (γ1 = 20.07018989) Skewed
altitude_high_meters is highly skewed (γ1 = 20.05804142) Skewed
altitude_mean_meters is highly skewed (γ1 = 20.06752535) Skewed
df_index has unique values Unique
ID has unique values Unique
Category.Two.Defects has 359 (27.4%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct count1312
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean657.0274390243902
Minimum0
Maximum1318
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile65.55
Q1327.75
median655.5
Q3986.25
95-th percentile1252.45
Maximum1318
Range1318
Interquartile range (IQR)658.5

Descriptive statistics

Standard deviation380.9259134
Coefficient of variation (CV)0.5797716971
Kurtosis-1.196408551
Mean657.027439
Median Absolute Deviation (MAD)329.5
Skewness0.01015246627
Sum862020
Variance145104.5515
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
131810.1%
 
43010.1%
 
43210.1%
 
43310.1%
 
43410.1%
 
43510.1%
 
43610.1%
 
43710.1%
 
43810.1%
 
43910.1%
 
Other values (1302)130299.2%
 
ValueCountFrequency (%) 
010.1%
 
110.1%
 
210.1%
 
310.1%
 
410.1%
 
ValueCountFrequency (%) 
131810.1%
 
131710.1%
 
131610.1%
 
131510.1%
 
131410.1%
 

ID
Categorical

UNIQUE

Distinct count1312
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size10.2 KiB
753
 
1
856
 
1
37
 
1
915
 
1
163
 
1
Other values (1307)
1307
ValueCountFrequency (%) 
75310.1%
 
85610.1%
 
3710.1%
 
91510.1%
 
16310.1%
 
112710.1%
 
49910.1%
 
12110.1%
 
122910.1%
 
40910.1%
 
Other values (1302)130299.2%
 

Length

Max length10
Median length3
Mean length3.160823171
Min length1

Species
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size10.2 KiB
Arabica
1311
unex guatemala, s.a.
 
1
ValueCountFrequency (%) 
Arabica131199.9%
 
unex guatemala, s.a.10.1%
 

Length

Max length20
Median length7
Mean length7.009908537
Min length7

Owner
Categorical

HIGH CARDINALITY

Distinct count305
Unique (%)23.4%
Missing8
Missing (%)0.6%
Memory size10.2 KiB
juan luis alvarado romero
 
155
racafe & cia s.c.a
 
60
exportadora de cafe condor s.a
 
54
kona pacific farmers cooperative
 
52
ipanema coffees
 
50
Other values (300)
933
ValueCountFrequency (%) 
juan luis alvarado romero15511.8%
 
racafe & cia s.c.a604.6%
 
exportadora de cafe condor s.a544.1%
 
kona pacific farmers cooperative524.0%
 
ipanema coffees503.8%
 
cqi taiwan icp cqi??????473.6%
 
lin, che-hao krude ???302.3%
 
nucoffee292.2%
 
carcafe ltda ci272.1%
 
the coffee source inc.231.8%
 
Other values (295)77759.2%
 

Length

Max length50
Median length22
Mean length21.26676829
Min length3

Country.of.Origin
Categorical

HIGH CORRELATION

Distinct count37
Unique (%)2.8%
Missing1
Missing (%)0.1%
Memory size10.2 KiB
Mexico
236
Colombia
183
Guatemala
181
Brazil
132
Taiwan
 
75
Other values (32)
504
ValueCountFrequency (%) 
Mexico23618.0%
 
Colombia18313.9%
 
Guatemala18113.8%
 
Brazil13210.1%
 
Taiwan755.7%
 
United States (Hawaii)735.6%
 
Honduras534.0%
 
Costa Rica513.9%
 
Ethiopia443.4%
 
Tanzania, United Republic Of403.0%
 
Other values (27)24318.5%
 

Length

Max length28
Median length8
Mean length8.887195122
Min length3

Farm.Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count550
Unique (%)57.5%
Missing356
Missing (%)27.1%
Memory size10.2 KiB
various
 
47
rio verde
 
23
several
 
20
finca medina
 
15
doi tung development project
 
13
Other values (545)
838
ValueCountFrequency (%) 
various473.6%
 
rio verde231.8%
 
several201.5%
 
finca medina151.1%
 
doi tung development project131.0%
 
fazenda capoeirnha131.0%
 
conquista / morito110.8%
 
los hicaques110.8%
 
capoeirinha100.8%
 
el papaturro90.7%
 
Other values (540)78459.8%
 
(Missing)35627.1%
 

Length

Max length73
Median length10
Mean length11.97179878
Min length1

Mill
Categorical

HIGH CARDINALITY
MISSING

Distinct count441
Unique (%)44.0%
Missing310
Missing (%)23.6%
Memory size10.2 KiB
beneficio ixchel
 
90
dry mill
 
39
trilladora boananza
 
38
ipanema coffees
 
16
neiva
 
15
Other values (436)
804
ValueCountFrequency (%) 
beneficio ixchel906.9%
 
dry mill393.0%
 
trilladora boananza382.9%
 
ipanema coffees161.2%
 
neiva151.1%
 
bachue141.1%
 
trilladora bonanza - armenia quindioa120.9%
 
beneficio siembras vision (154)120.9%
 
cigrah s.a de c.v.120.9%
 
cadexsa120.9%
 
Other values (431)74256.6%
 
(Missing)31023.6%
 

Length

Max length77
Median length15
Mean length15.34679878
Min length1

ICO.Number
Categorical

HIGH CARDINALITY
MISSING

Distinct count842
Unique (%)72.3%
Missing147
Missing (%)11.2%
Memory size10.2 KiB
0
 
67
Taiwan
 
31
2222
 
11
-
 
9
002/4177/0150
 
7
Other values (837)
1040
ValueCountFrequency (%) 
0675.1%
 
Taiwan312.4%
 
2222110.8%
 
-90.7%
 
002/4177/015070.5%
 
Taiwan??70.5%
 
002/1660/010570.5%
 
unknown60.5%
 
160.5%
 
002/1660/008060.5%
 
Other values (832)100876.8%
 
(Missing)14711.2%
 

Length

Max length40
Median length9
Mean length8.362804878
Min length1

Company
Categorical

HIGH CARDINALITY
MISSING

Distinct count270
Unique (%)24.5%
Missing210
Missing (%)16.0%
Memory size10.2 KiB
unex guatemala, s.a.
 
85
ipanema coffees
 
50
exportadora de cafe condor s.a
 
40
kona pacific farmers cooperative
 
40
racafe & cia s.c.a
 
40
Other values (265)
847
ValueCountFrequency (%) 
unex guatemala, s.a.856.5%
 
ipanema coffees503.8%
 
exportadora de cafe condor s.a403.0%
 
kona pacific farmers cooperative403.0%
 
racafe & cia s.c.a403.0%
 
blossom valley????251.9%
 
carcafe ltda251.9%
 
nucoffee241.8%
 
taiwan coffee laboratory201.5%
 
????201.5%
 
Other values (260)73355.9%
 
(Missing)21016.0%
 

Length

Max length80
Median length18
Mean length18.35746951
Min length3

Altitude
Categorical

HIGH CARDINALITY
MISSING

Distinct count384
Unique (%)35.3%
Missing223
Missing (%)17.0%
Memory size10.2 KiB
1100
 
43
1200
 
41
1300
 
32
1400
 
32
4300
 
31
Other values (379)
910
ValueCountFrequency (%) 
1100433.3%
 
1200413.1%
 
1300322.4%
 
1400322.4%
 
4300312.4%
 
1250302.3%
 
1500302.3%
 
1700282.1%
 
1550241.8%
 
1600221.7%
 
Other values (374)77659.1%
 
(Missing)22317.0%
 

Length

Max length41
Median length4
Mean length5.825457317
Min length1

Region
Categorical

HIGH CARDINALITY
MISSING

Distinct count338
Unique (%)27.0%
Missing58
Missing (%)4.4%
Memory size10.2 KiB
huila
 
112
oriente
 
79
south of minas
 
68
kona
 
66
veracruz
 
35
Other values (333)
894
ValueCountFrequency (%) 
huila1128.5%
 
oriente796.0%
 
south of minas685.2%
 
kona665.0%
 
veracruz352.7%
 
tarrazu191.4%
 
comayagua171.3%
 
huehuetenango161.2%
 
san marcos161.2%
 
marcala151.1%
 
Other values (328)81161.8%
 
(Missing)584.4%
 

Length

Max length76
Median length8
Mean length10.52591463
Min length2

Producer
Categorical

HIGH CARDINALITY
MISSING

Distinct count663
Unique (%)61.3%
Missing231
Missing (%)17.6%
Memory size10.2 KiB
La Plata
 
30
Ipanema Agrícola SA
 
22
Doi Tung Development Project
 
17
???
 
14
Ipanema Agricola
 
12
Other values (658)
986
ValueCountFrequency (%) 
La Plata302.3%
 
Ipanema Agrícola SA221.7%
 
Doi Tung Development Project171.3%
 
???141.1%
 
Ipanema Agricola120.9%
 
VARIOS120.9%
 
Ipanema Agricola S.A110.8%
 
ROBERTO MONTERROSO100.8%
 
AMILCAR LAPOLA90.7%
 
LA PLATA90.7%
 
Other values (653)93571.3%
 
(Missing)23117.6%
 

Length

Max length104
Median length17
Mean length17.52591463
Min length1

Number.of.Bags
Categorical

HIGH CARDINALITY

Distinct count131
Unique (%)10.0%
Missing1
Missing (%)0.1%
Memory size10.2 KiB
250
240
275
176
10
 
108
1
 
87
300
 
71
Other values (126)
629
ValueCountFrequency (%) 
25024018.3%
 
27517613.4%
 
101088.2%
 
1876.6%
 
300715.4%
 
320705.3%
 
50423.2%
 
100372.8%
 
20352.7%
 
2292.2%
 
Other values (121)41631.7%
 

Length

Max length12
Median length3
Mean length2.432926829
Min length1

Bag.Weight
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count57
Unique (%)4.3%
Missing1
Missing (%)0.1%
Memory size10.2 KiB
1 kg
326
60 kg
242
69 kg
200
70 kg
156
2 kg
114
Other values (52)
273
ValueCountFrequency (%) 
1 kg32624.8%
 
60 kg24218.4%
 
69 kg20015.2%
 
70 kg15611.9%
 
2 kg1148.7%
 
100 lbs594.5%
 
30 kg292.2%
 
5 lbs211.6%
 
6191.4%
 
20 kg141.1%
 
Other values (47)13110.0%
 

Length

Max length8
Median length5
Mean length4.701981707
Min length1

In.Country.Partner
Categorical

HIGH CORRELATION

Distinct count27
Unique (%)2.1%
Missing1
Missing (%)0.1%
Memory size10.2 KiB
Specialty Coffee Association
295
AMECAFE
205
Almacafé
178
Asociacion Nacional Del Café
154
Brazil Specialty Coffee Association
 
67
Other values (22)
412
ValueCountFrequency (%) 
Specialty Coffee Association29522.5%
 
AMECAFE20515.6%
 
Almacafé17813.6%
 
Asociacion Nacional Del Café15411.7%
 
Brazil Specialty Coffee Association675.1%
 
Instituto Hondureño del Café604.6%
 
Blossom Valley International594.5%
 
Africa Fine Coffee Association493.7%
 
Specialty Coffee Association of Costa Rica423.2%
 
NUCOFFEE362.7%
 
Other values (17)16612.7%
 

Length

Max length88
Median length28
Mean length23.2804878
Min length3

Harvest.Year
Categorical

HIGH CORRELATION
MISSING

Distinct count47
Unique (%)3.7%
Missing49
Missing (%)3.7%
Memory size10.2 KiB
2012
351
2014
226
2013
170
2015
125
2016
122
Other values (42)
269
ValueCountFrequency (%) 
201235126.8%
 
201422617.2%
 
201317013.0%
 
20151259.5%
 
20161229.3%
 
2017685.2%
 
2015/2016282.1%
 
2013/2014282.1%
 
2011262.0%
 
2014/2015191.4%
 
Other values (37)1007.6%
 
(Missing)493.7%
 

Length

Max length24
Median length4
Mean length4.669969512
Min length3

Grading.Date
Categorical

HIGH CARDINALITY

Distinct count556
Unique (%)42.4%
Missing2
Missing (%)0.2%
Memory size10.2 KiB
July 11th, 2012
 
25
December 26th, 2013
 
24
June 6th, 2012
 
19
August 30th, 2012
 
18
July 26th, 2012
 
15
Other values (551)
1209
ValueCountFrequency (%) 
July 11th, 2012251.9%
 
December 26th, 2013241.8%
 
June 6th, 2012191.4%
 
August 30th, 2012181.4%
 
July 26th, 2012151.1%
 
September 27th, 2012131.0%
 
March 29th, 2013131.0%
 
October 8th, 2015131.0%
 
June 17th, 2010120.9%
 
September 17th, 2012110.8%
 
Other values (546)114787.4%
 

Length

Max length20
Median length16
Mean length16.56783537
Min length3

Owner.1
Categorical

HIGH CARDINALITY

Distinct count308
Unique (%)23.7%
Missing10
Missing (%)0.8%
Memory size10.2 KiB
Juan Luis Alvarado Romero
 
154
Racafe & Cia S.C.A
 
60
Exportadora de Cafe Condor S.A
 
54
Kona Pacific Farmers Cooperative
 
52
Ipanema Coffees
 
50
Other values (303)
932
ValueCountFrequency (%) 
Juan Luis Alvarado Romero15411.7%
 
Racafe & Cia S.C.A604.6%
 
Exportadora de Cafe Condor S.A544.1%
 
Kona Pacific Farmers Cooperative524.0%
 
Ipanema Coffees503.8%
 
CQI Taiwan ICP CQI??????463.5%
 
Lin, Che-Hao Krude ???302.3%
 
NUCOFFEE292.2%
 
CARCAFE LTDA CI272.1%
 
The Coffee Source Inc.231.8%
 
Other values (298)77759.2%
 

Length

Max length50
Median length22
Mean length21.22408537
Min length1

Variety
Categorical

HIGH CORRELATION
MISSING

Distinct count30
Unique (%)2.7%
Missing205
Missing (%)15.6%
Memory size10.2 KiB
Caturra
256
Bourbon
225
Typica
209
Other
108
Catuai
73
Other values (25)
236
ValueCountFrequency (%) 
Caturra25619.5%
 
Bourbon22517.1%
 
Typica20915.9%
 
Other1088.2%
 
Catuai735.6%
 
Hawaiian Kona443.4%
 
Yellow Bourbon352.7%
 
Mundo Novo332.5%
 
Catimor201.5%
 
SL14171.3%
 
Other values (20)876.6%
 
(Missing)20515.6%
 

Length

Max length21
Median length6
Mean length6.393292683
Min length3

Processing.Method
Categorical

HIGH CORRELATION
MISSING

Distinct count6
Unique (%)0.5%
Missing156
Missing (%)11.9%
Memory size10.2 KiB
Washed / Wet
809
Natural / Dry
250
Semi-washed / Semi-pulped
 
56
Other
 
26
Pulped natural / honey
 
14
ValueCountFrequency (%) 
Washed / Wet80961.7%
 
Natural / Dry25019.1%
 
Semi-washed / Semi-pulped564.3%
 
Other262.0%
 
Pulped natural / honey141.1%
 
810.1%
 
(Missing)15611.9%
 

Length

Max length25
Median length12
Mean length11.63490854
Min length1

Aroma
Real number (ℝ≥0)

Distinct count34
Unique (%)2.6%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.566689602446483
Minimum0.0
Maximum10.0
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile7.08
Q17.42
median7.58
Q37.75
95-th percentile8.08
Maximum10
Range10
Interquartile range (IQR)0.33

Descriptive statistics

Standard deviation0.3842511432
Coefficient of variation (CV)0.05078193548
Kurtosis116.92108
Mean7.566689602
Median Absolute Deviation (MAD)0.17
Skewness-5.868718879
Sum9897.23
Variance0.1476489411
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.6717313.2%
 
7.516212.3%
 
7.5814911.4%
 
7.751229.3%
 
7.421209.1%
 
7.831017.7%
 
7.33967.3%
 
7.25775.9%
 
7.92574.3%
 
7.17453.4%
 
Other values (24)20615.7%
 
ValueCountFrequency (%) 
010.1%
 
5.0810.1%
 
6.1710.1%
 
6.3310.1%
 
6.4210.1%
 
ValueCountFrequency (%) 
1010.1%
 
8.7510.1%
 
8.6720.2%
 
8.5810.1%
 
8.530.2%
 

Flavor
Real number (ℝ≥0)

Distinct count36
Unique (%)2.8%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.520917431192659
Minimum0.0
Maximum10.0
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile6.948
Q17.33
median7.58
Q37.75
95-th percentile8
Maximum10
Range10
Interquartile range (IQR)0.42

Descriptive statistics

Standard deviation0.4054876999
Coefficient of variation (CV)0.05391465916
Kurtosis91.36064171
Mean7.520917431
Median Absolute Deviation (MAD)0.17
Skewness-4.863105413
Sum9837.36
Variance0.1644202747
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.516412.5%
 
7.5816112.3%
 
7.6714511.1%
 
7.751209.1%
 
7.421148.7%
 
7.331098.3%
 
7.83856.5%
 
7.25634.8%
 
7.17564.3%
 
7.08423.2%
 
Other values (26)24919.0%
 
ValueCountFrequency (%) 
010.1%
 
6.0810.1%
 
6.1720.2%
 
6.3330.2%
 
6.4210.1%
 
ValueCountFrequency (%) 
1010.1%
 
8.8310.1%
 
8.6740.3%
 
8.5820.2%
 
8.550.4%
 

Aftertaste
Real number (ℝ≥0)

Distinct count35
Unique (%)2.7%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.397775229357799
Minimum0.0
Maximum8.67
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile6.83
Q17.25
median7.42
Q37.58
95-th percentile7.92
Maximum8.67
Range8.67
Interquartile range (IQR)0.33

Descriptive statistics

Standard deviation0.4049340165
Coefficient of variation (CV)0.05473726951
Kurtosis84.97209599
Mean7.397775229
Median Absolute Deviation (MAD)0.17
Skewness-4.852962343
Sum9676.29
Variance0.1639715577
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.516112.3%
 
7.3315011.4%
 
7.421279.7%
 
7.581259.5%
 
7.251037.9%
 
7.67987.5%
 
7.17896.8%
 
7.75816.2%
 
7624.7%
 
7.83614.6%
 
Other values (25)25119.1%
 
ValueCountFrequency (%) 
010.1%
 
6.1770.5%
 
6.2510.1%
 
6.3360.5%
 
6.4250.4%
 
ValueCountFrequency (%) 
8.6710.1%
 
8.5820.2%
 
8.540.3%
 
8.4230.2%
 
8.3320.2%
 

Acidity
Real number (ℝ≥0)

SKEWED

Distinct count32
Unique (%)2.4%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.585175840978593
Minimum0.0
Maximum74.75
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile7
Q17.33
median7.5
Q37.75
95-th percentile8.08
Maximum74.75
Range74.75
Interquartile range (IQR)0.42

Descriptive statistics

Standard deviation1.897340235
Coefficient of variation (CV)0.2501379368
Kurtosis1204.18733
Mean7.585175841
Median Absolute Deviation (MAD)0.17
Skewness33.94016411
Sum9921.41
Variance3.599899969
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.515912.1%
 
7.5815011.4%
 
7.6714310.9%
 
7.421279.7%
 
7.751229.3%
 
7.331098.3%
 
7.25856.5%
 
7.17725.5%
 
7.83725.5%
 
8473.6%
 
Other values (22)22216.9%
 
ValueCountFrequency (%) 
010.1%
 
5.2510.1%
 
6.0810.1%
 
6.2510.1%
 
6.510.1%
 
ValueCountFrequency (%) 
74.7510.1%
 
8.7510.1%
 
8.5810.1%
 
8.570.5%
 
8.4260.5%
 

Body
Real number (ℝ≥0)

Distinct count32
Unique (%)2.4%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.5125611620795105
Minimum0.0
Maximum8.58
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile7.08
Q17.33
median7.5
Q37.67
95-th percentile8
Maximum8.58
Range8.58
Interquartile range (IQR)0.34

Descriptive statistics

Standard deviation0.4134971499
Coefficient of variation (CV)0.05504076985
Kurtosis161.2857803
Mean7.512561162
Median Absolute Deviation (MAD)0.17
Skewness-9.06857238
Sum9826.43
Variance0.170979893
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.519815.1%
 
7.6714911.4%
 
7.5813610.4%
 
7.3313110.0%
 
7.421249.5%
 
7.751078.2%
 
7.25856.5%
 
7.83826.2%
 
7.17685.2%
 
7.92483.7%
 
Other values (22)18013.7%
 
ValueCountFrequency (%) 
010.1%
 
0.1110.1%
 
5.2510.1%
 
6.3320.2%
 
6.4210.1%
 
ValueCountFrequency (%) 
8.5810.1%
 
8.530.2%
 
8.4230.2%
 
8.3360.5%
 
8.2550.4%
 

Balance
Real number (ℝ≥0)

Distinct count32
Unique (%)2.4%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean7.512454128440368
Minimum0.0
Maximum8.75
Zeros2
Zeros (%)0.2%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile6.92
Q17.33
median7.5
Q37.75
95-th percentile8.08
Maximum8.75
Range8.75
Interquartile range (IQR)0.42

Descriptive statistics

Standard deviation0.4559413295
Coefficient of variation (CV)0.06069139615
Kurtosis111.7153503
Mean7.512454128
Median Absolute Deviation (MAD)0.17
Skewness-6.831097072
Sum9826.29
Variance0.207882496
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
7.517113.0%
 
7.6714511.1%
 
7.581279.7%
 
7.421209.1%
 
7.751037.9%
 
7.33997.5%
 
7.83977.4%
 
7.17715.4%
 
7.25634.8%
 
7463.5%
 
Other values (22)26620.3%
 
ValueCountFrequency (%) 
020.2%
 
6.0810.1%
 
6.1730.2%
 
6.3310.1%
 
6.4210.1%
 
ValueCountFrequency (%) 
8.7520.2%
 
8.5870.5%
 
8.570.5%
 
8.4270.5%
 
8.3370.5%
 

Uniformity
Real number (ℝ≥0)

Distinct count10
Unique (%)0.8%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean9.827408256880734
Minimum0.0
Maximum10.0
Zeros2
Zeros (%)0.2%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile8.67
Q110
median10
Q310
95-th percentile10
Maximum10
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.6202594134
Coefficient of variation (CV)0.06311525859
Kurtosis102.9496688
Mean9.827408257
Median Absolute Deviation (MAD)0
Skewness-8.095186971
Sum12854.25
Variance0.3847217399
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10112685.8%
 
9.331118.5%
 
8.67312.4%
 
8241.8%
 
6.6770.5%
 
630.2%
 
7.3320.2%
 
020.2%
 
910.1%
 
9.510.1%
 
(Missing)40.3%
 
ValueCountFrequency (%) 
020.2%
 
630.2%
 
6.6770.5%
 
7.3320.2%
 
8241.8%
 
ValueCountFrequency (%) 
10112685.8%
 
9.510.1%
 
9.331118.5%
 
910.1%
 
8.67312.4%
 

Clean.Cup
Real number (ℝ≥0)

Distinct count11
Unique (%)0.8%
Missing5
Missing (%)0.4%
Infinite0
Infinite (%)0.0%
Mean9.833121652639631
Minimum0.0
Maximum10.0
Zeros2
Zeros (%)0.2%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile9.33
Q110
median10
Q310
95-th percentile10
Maximum10
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.7723632038
Coefficient of variation (CV)0.07854710143
Kurtosis69.01590398
Mean9.833121653
Median Absolute Deviation (MAD)0
Skewness-7.371180435
Sum12851.89
Variance0.5965449186
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10119190.8%
 
9.33574.3%
 
8.67161.2%
 
6.67131.0%
 
8131.0%
 
660.5%
 
7.3330.2%
 
5.3330.2%
 
2.6720.2%
 
020.2%
 
(Missing)50.4%
 
ValueCountFrequency (%) 
020.2%
 
1.3310.1%
 
2.6720.2%
 
5.3330.2%
 
660.5%
 
ValueCountFrequency (%) 
10119190.8%
 
9.33574.3%
 
8.67161.2%
 
8131.0%
 
7.3330.2%
 

Sweetness
Real number (ℝ≥0)

Distinct count8
Unique (%)0.6%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean9.9040749235474
Minimum0.0
Maximum10.0
Zeros1
Zeros (%)0.1%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile9.33
Q110
median10
Q310
95-th percentile10
Maximum10
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.5309599084
Coefficient of variation (CV)0.05361024755
Kurtosis157.8063887
Mean9.904074924
Median Absolute Deviation (MAD)0
Skewness-10.77587083
Sum12954.53
Variance0.2819184244
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10121792.8%
 
9.33594.5%
 
8.67120.9%
 
880.6%
 
6.6770.5%
 
630.2%
 
1.3310.1%
 
010.1%
 
(Missing)40.3%
 
ValueCountFrequency (%) 
010.1%
 
1.3310.1%
 
630.2%
 
6.6770.5%
 
880.6%
 
ValueCountFrequency (%) 
10121792.8%
 
9.33594.5%
 
8.67120.9%
 
880.6%
 
6.6770.5%
 

Cupper.Points
Categorical

HIGH CORRELATION

Distinct count43
Unique (%)3.3%
Missing4
Missing (%)0.3%
Memory size10.2 KiB
7.5
151
7.58
 
135
7.33
 
114
7.67
 
113
7.42
 
103
Other values (38)
692
ValueCountFrequency (%) 
7.515111.5%
 
7.5813510.3%
 
7.331148.7%
 
7.671138.6%
 
7.421037.9%
 
7.25856.5%
 
7.75846.4%
 
7.83816.2%
 
7.17634.8%
 
7.92524.0%
 
Other values (33)32724.9%
 

Length

Max length17
Median length4
Mean length3.639481707
Min length1

Total.Cup.Points
Categorical

HIGH CARDINALITY

Distinct count179
Unique (%)13.7%
Missing4
Missing (%)0.3%
Memory size10.2 KiB
83.17
 
38
83
 
37
82.42
 
31
82.33
 
29
82.75
 
29
Other values (174)
1144
ValueCountFrequency (%) 
83.17382.9%
 
83372.8%
 
82.42312.4%
 
82.33292.2%
 
82.75292.2%
 
82.67262.0%
 
81.83262.0%
 
82.92262.0%
 
81.67251.9%
 
83.5241.8%
 
Other values (169)101777.5%
 

Length

Max length29
Median length5
Mean length4.616615854
Min length1

Moisture
Categorical

HIGH CORRELATION

Distinct count24
Unique (%)1.8%
Missing4
Missing (%)0.3%
Memory size10.2 KiB
0.11
377
0.12
284
0
252
0.1
180
0.13
 
75
Other values (19)
140
ValueCountFrequency (%) 
0.1137728.7%
 
0.1228421.6%
 
025219.2%
 
0.118013.7%
 
0.13755.7%
 
0.09262.0%
 
0.14231.8%
 
0.08161.2%
 
0.01151.1%
 
0.1580.6%
 
Other values (14)524.0%
 

Length

Max length40
Median length4
Mean length3.308689024
Min length1

Category.One.Defects
Categorical

HIGH CORRELATION

Distinct count17
Unique (%)1.3%
Missing4
Missing (%)0.3%
Memory size10.2 KiB
0
1107
1
 
101
2
 
38
3
 
18
4
 
16
Other values (12)
 
28
ValueCountFrequency (%) 
0110784.4%
 
11017.7%
 
2382.9%
 
3181.4%
 
4161.2%
 
590.7%
 
1040.3%
 
630.2%
 
730.2%
 
3120.2%
 
Other values (7)70.5%
 
(Missing)40.3%
 

Length

Max length40
Median length1
Mean length1.043445122
Min length1

Quakers
Categorical

HIGH CORRELATION

Distinct count12
Unique (%)0.9%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
0
1212
1
 
39
2
 
30
4
 
5
5
 
5
Other values (7)
 
16
ValueCountFrequency (%) 
0121292.4%
 
1393.0%
 
2302.3%
 
450.4%
 
550.4%
 
350.4%
 
640.3%
 
730.2%
 
810.1%
 
1110.1%
 
Other values (2)20.2%
 
(Missing)50.4%
 

Length

Max length3
Median length1
Mean length1.008384146
Min length1

Color
Categorical

MISSING

Distinct count4
Unique (%)0.4%
Missing220
Missing (%)16.8%
Memory size10.2 KiB
Green
848
Bluish-Green
 
112
Blue-Green
 
81
None
 
51
ValueCountFrequency (%) 
Green84864.6%
 
Bluish-Green1128.5%
 
Blue-Green816.2%
 
None513.9%
 
(Missing)22016.8%
 

Length

Max length12
Median length5
Mean length5.532012195
Min length3

Category.Two.Defects
Real number (ℝ≥0)

ZEROS

Distinct count38
Unique (%)2.9%
Missing5
Missing (%)0.4%
Infinite0
Infinite (%)0.0%
Mean3.595256312165264
Minimum0.0
Maximum55.0
Zeros359
Zeros (%)27.4%
Memory size10.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median2
Q34
95-th percentile13
Maximum55
Range55
Interquartile range (IQR)4

Descriptive statistics

Standard deviation5.3528549
Coefficient of variation (CV)1.488866004
Kurtosis19.83427897
Mean3.595256312
Median Absolute Deviation (MAD)2
Skewness3.652168336
Sum4699
Variance28.65305558
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
035927.4%
 
120015.2%
 
217813.6%
 
313310.1%
 
41189.0%
 
5735.6%
 
6423.2%
 
7393.0%
 
8292.2%
 
9221.7%
 
Other values (28)1148.7%
 
ValueCountFrequency (%) 
035927.4%
 
120015.2%
 
217813.6%
 
313310.1%
 
41189.0%
 
ValueCountFrequency (%) 
5510.1%
 
4710.1%
 
4510.1%
 
4010.1%
 
3810.1%
 

Expiration
Categorical

HIGH CARDINALITY

Distinct count554
Unique (%)42.4%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
July 11th, 2013
 
25
December 26th, 2014
 
24
June 6th, 2013
 
19
August 30th, 2013
 
18
July 26th, 2013
 
15
Other values (549)
1206
ValueCountFrequency (%) 
July 11th, 2013251.9%
 
December 26th, 2014241.8%
 
June 6th, 2013191.4%
 
August 30th, 2013181.4%
 
July 26th, 2013151.1%
 
September 27th, 2013131.0%
 
March 29th, 2014131.0%
 
October 7th, 2016131.0%
 
June 17th, 2011120.9%
 
September 17th, 2013110.8%
 
Other values (544)114487.2%
 

Length

Max length20
Median length16
Mean length16.5464939
Min length3

Certification.Body
Categorical

HIGH CORRELATION

Distinct count25
Unique (%)1.9%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
Specialty Coffee Association
293
AMECAFE
205
Almacafé
178
Asociacion Nacional Del Café
154
Brazil Specialty Coffee Association
 
67
Other values (20)
410
ValueCountFrequency (%) 
Specialty Coffee Association29322.3%
 
AMECAFE20515.6%
 
Almacafé17813.6%
 
Asociacion Nacional Del Café15411.7%
 
Brazil Specialty Coffee Association675.1%
 
Instituto Hondureño del Café604.6%
 
Blossom Valley International584.4%
 
Africa Fine Coffee Association493.7%
 
Specialty Coffee Association of Costa Rica433.3%
 
NUCOFFEE362.7%
 
Other values (15)16412.5%
 

Length

Max length88
Median length28
Mean length23.23932927
Min length3

Certification.Address
Categorical

HIGH CORRELATION

Distinct count28
Unique (%)2.1%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
36d0d00a3724338ba7937c52a378d085f2172daa
293
59e396ad6e22a1c22b248f958e1da2bd8af85272
204
e493c36c2d076bf273064f7ac23ad562af257a25
178
b1f20fe3a819fd6b2ee0eb8fdc3da256604f1e53
154
3297cfa4c538e3dd03f72cc4082c54f7999e1f9d
 
67
Other values (23)
411
ValueCountFrequency (%) 
36d0d00a3724338ba7937c52a378d085f2172daa29322.3%
 
59e396ad6e22a1c22b248f958e1da2bd8af8527220415.5%
 
e493c36c2d076bf273064f7ac23ad562af257a2517813.6%
 
b1f20fe3a819fd6b2ee0eb8fdc3da256604f1e5315411.7%
 
3297cfa4c538e3dd03f72cc4082c54f7999e1f9d675.1%
 
b4660a57e9f8cc613ae5b8f02bfce8634c763ab4604.6%
 
fc45352eee499d8470cf94c9827922fb745bf815584.4%
 
073285c0d45e2f5539012d969937e529564fa6fe483.7%
 
8e0b118f3cf3121ab27c5387deacdb7d4d2a60b1423.2%
 
567f200bcc17a90070cb952647bf88141ad9c80c362.7%
 
Other values (18)16712.7%
 

Length

Max length40
Median length40
Mean length39.8589939
Min length3

Certification.Contact
Categorical

HIGH CORRELATION

Distinct count26
Unique (%)2.0%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660
293
0eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a7
204
70d3c0c26f89e00fdae6fb39ff54f0d2eb1c38ab
178
724f04ad10ed31dbb9d260f0dfd221ba48be8a95
154
8900f0bf1d0b2bafe6807a73562c7677d57eb980
 
67
Other values (21)
411
ValueCountFrequency (%) 
0878a7d4b9d35ddbf0fe2ce69a2062cceb45a66029322.3%
 
0eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a720415.5%
 
70d3c0c26f89e00fdae6fb39ff54f0d2eb1c38ab17813.6%
 
724f04ad10ed31dbb9d260f0dfd221ba48be8a9515411.7%
 
8900f0bf1d0b2bafe6807a73562c7677d57eb980675.1%
 
7f521ca403540f81ec99daec7da19c2788393880604.6%
 
de73fc9412358b523d3a641501e542f31d2668b0584.4%
 
c4ab13415cdd69376a93780c0166e7b1a10481ea493.7%
 
5eb2b7129d9714c43825e44dc3bca9423de209e9433.3%
 
aa2ff513ffb9c844462a1fb07c599bce7f3bb53d362.7%
 
Other values (16)16512.6%
 

Length

Max length40
Median length40
Mean length39.8589939
Min length3
Distinct count2
Unique (%)0.2%
Missing5
Missing (%)0.4%
Memory size10.2 KiB
m
1125
ft
 
182
ValueCountFrequency (%) 
m112585.7%
 
ft18213.9%
 
(Missing)50.4%
 

Length

Max length3
Median length1
Mean length1.146341463
Min length1

altitude_low_meters
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count188
Unique (%)17.4%
Missing231
Missing (%)17.6%
Infinite0
Infinite (%)0.0%
Mean1762.0268884366326
Minimum1.0
Maximum190164.0
Zeros0
Zeros (%)0.0%
Memory size10.2 KiB

Quantile statistics

Minimum1
5-th percentile442
Q11100
median1310.64
Q31600
95-th percentile1850
Maximum190164
Range190163
Interquartile range (IQR)500

Descriptive statistics

Standard deviation8779.88323
Coefficient of variation (CV)4.982831583
Kurtosis413.3246208
Mean1762.026888
Median Absolute Deviation (MAD)239.36
Skewness20.07018989
Sum1904751.066
Variance77086349.53
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1200806.1%
 
1600655.0%
 
1400594.5%
 
1500544.1%
 
1100544.1%
 
1300483.7%
 
1800413.1%
 
1250382.9%
 
1700362.7%
 
1550312.4%
 
Other values (178)57543.8%
 
(Missing)23117.6%
 
ValueCountFrequency (%) 
1141.1%
 
1230.2%
 
1320.2%
 
5010.1%
 
10020.2%
 
ValueCountFrequency (%) 
19016420.2%
 
11000010.1%
 
1100010.1%
 
428710.1%
 
400110.1%
 

altitude_high_meters
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count188
Unique (%)17.4%
Missing231
Missing (%)17.6%
Infinite0
Infinite (%)0.0%
Mean1811.4585406105462
Minimum1.0
Maximum190164.0
Zeros0
Zeros (%)0.0%
Memory size10.2 KiB

Quantile statistics

Minimum1
5-th percentile442
Q11100
median1350
Q31650
95-th percentile1950
Maximum190164
Range190163
Interquartile range (IQR)550

Descriptive statistics

Standard deviation8779.208199
Coefficient of variation (CV)4.846485858
Kurtosis412.9991037
Mean1811.458541
Median Absolute Deviation (MAD)250
Skewness20.05804142
Sum1958186.682
Variance77074496.61
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1200655.0%
 
1400634.8%
 
1100534.0%
 
1500513.9%
 
1300443.4%
 
1800443.4%
 
1700423.2%
 
1250393.0%
 
1600342.6%
 
1950332.5%
 
Other values (178)61346.7%
 
(Missing)23117.6%
 
ValueCountFrequency (%) 
1120.9%
 
1230.2%
 
1320.2%
 
5010.1%
 
10010.1%
 
ValueCountFrequency (%) 
19016420.2%
 
11000010.1%
 
1100010.1%
 
590010.1%
 
428710.1%
 

altitude_mean_meters
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count201
Unique (%)18.6%
Missing231
Missing (%)17.6%
Infinite0
Infinite (%)0.0%
Mean1786.7427145235893
Minimum1.0
Maximum190164.0
Zeros0
Zeros (%)0.0%
Memory size10.2 KiB

Quantile statistics

Minimum1
5-th percentile442
Q11100
median1317
Q31600
95-th percentile1880
Maximum190164
Range190163
Interquartile range (IQR)500

Descriptive statistics

Standard deviation8779.044646
Coefficient of variation (CV)4.913435256
Kurtosis413.2568432
Mean1786.742715
Median Absolute Deviation (MAD)233
Skewness20.06752535
Sum1931468.874
Variance77071624.9
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1200665.0%
 
1400524.0%
 
1100513.9%
 
1300503.8%
 
1500443.4%
 
1250393.0%
 
1700362.7%
 
1600352.7%
 
1750342.6%
 
1550342.6%
 
Other values (191)64048.8%
 
(Missing)23117.6%
 
ValueCountFrequency (%) 
1120.9%
 
1230.2%
 
1320.2%
 
5010.1%
 
10010.1%
 
ValueCountFrequency (%) 
19016420.2%
 
11000010.1%
 
1100010.1%
 
428710.1%
 
400110.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexIDSpeciesOwnerCountry.of.OriginFarm.NameMillICO.NumberCompanyAltitudeRegionProducerNumber.of.BagsBag.WeightIn.Country.PartnerHarvest.YearGrading.DateOwner.1VarietyProcessing.MethodAromaFlavorAftertasteAcidityBodyBalanceUniformityClean.CupSweetnessCupper.PointsTotal.Cup.PointsMoistureCategory.One.DefectsQuakersColorCategory.Two.DefectsExpirationCertification.BodyCertification.AddressCertification.Contactunit_of_measurementaltitude_low_metersaltitude_high_metersaltitude_mean_meters
001Arabicametad plcEthiopiametad plcmetad plc2014/2015metad agricultural developmet plc1950-2200guji-hambelaMETAD PLC30060 kgMETAD Agricultural Development plc2014April 4th, 2015metad plcNaNWashed / Wet8.678.838.678.758.508.4210.0010.010.008.7590.580.1200Green0.0April 3rd, 2016METAD Agricultural Development plc309fcf77415a3661ae83e027f7e5f05dad786e4419fef5a731de2db57d16da10287413f5f99bc2ddm1950.02200.02075.0
112Arabicametad plcEthiopiametad plcmetad plc2014/2015metad agricultural developmet plc1950-2200guji-hambelaMETAD PLC30060 kgMETAD Agricultural Development plc2014April 4th, 2015metad plcOtherWashed / Wet8.758.678.508.588.428.4210.0010.010.008.5889.920.1200Green1.0April 3rd, 2016METAD Agricultural Development plc309fcf77415a3661ae83e027f7e5f05dad786e4419fef5a731de2db57d16da10287413f5f99bc2ddm1950.02200.02075.0
223Arabicagrounds for health adminGuatemalasan marcos barrancas "san cristobal cuchNaNNaNNaN1600 - 1800 mNaNNaN51Specialty Coffee AssociationNaNMay 31st, 2010Grounds for Health AdminBourbonNaN8.428.508.428.428.338.4210.0010.010.009.2589.75000NaN0.0May 31st, 2011Specialty Coffee Association36d0d00a3724338ba7937c52a378d085f2172daa0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660m1600.01800.01700.0
334Arabicayidnekachew dabessaEthiopiayidnekachew dabessa coffee plantationwolensuNaNyidnekachew debessa coffee plantation1800-2200oromiaYidnekachew Dabessa Coffee Plantation32060 kgMETAD Agricultural Development plc2014March 26th, 2015Yidnekachew DabessaNaNNatural / Dry8.178.588.428.428.508.2510.0010.010.008.67890.1100Green2.0March 25th, 2016METAD Agricultural Development plc309fcf77415a3661ae83e027f7e5f05dad786e4419fef5a731de2db57d16da10287413f5f99bc2ddm1800.02200.02000.0
445Arabicametad plcEthiopiametad plcmetad plc2014/2015metad agricultural developmet plc1950-2200guji-hambelaMETAD PLC30060 kgMETAD Agricultural Development plc2014April 4th, 2015metad plcOtherWashed / Wet8.258.508.258.508.428.3310.0010.010.008.5888.830.1200Green2.0April 3rd, 2016METAD Agricultural Development plc309fcf77415a3661ae83e027f7e5f05dad786e4419fef5a731de2db57d16da10287413f5f99bc2ddm1950.02200.02075.0
556Arabicaji-ae ahnBrazilNaNNaNNaNNaNNaNNaNNaN10030 kgSpecialty Coffee Institute of Asia2013September 3rd, 2013Ji-Ae AhnNaNNatural / Dry8.588.428.428.508.258.3310.0010.010.008.3388.830.1100Bluish-Green1.0September 3rd, 2014Specialty Coffee Institute of Asia726e4891cf2c9a4848768bd34b668124d12c4224b70da261fcc84831e3e9620c30a8701540abc200mNaNNaNNaN
667Arabicahugo valdiviaPeruNaNhvcNaNrichmond investment-coffee departmentNaNNaNHVC10069 kgSpecialty Coffee Institute of Asia2012September 17th, 2012Hugo ValdiviaOtherWashed / Wet8.428.508.338.508.258.2510.0010.010.008.588.750.1100Bluish-Green0.0September 17th, 2013Specialty Coffee Institute of Asia726e4891cf2c9a4848768bd34b668124d12c4224b70da261fcc84831e3e9620c30a8701540abc200mNaNNaNNaN
778Arabicaethiopia commodity exchangeEthiopiaaolmec.p.w.e010/0338NaN1570-1700oromiaBazen Agricultural & Industrial Dev't Plc30060 kgEthiopia Commodity ExchangeMarch 2010September 2nd, 2010Ethiopia Commodity ExchangeNaNNaN8.258.338.508.428.338.5010.0010.09.33988.670.0300NaN0.0September 2nd, 2011Ethiopia Commodity Exchangea176532400aebdc345cf3d870f84ed3ecab6249e61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24bm1570.01700.01635.0
889Arabicaethiopia commodity exchangeEthiopiaaolmec.p.w.e010/0338NaN1570-1700oromiyaBazen Agricultural & Industrial Dev't Plc30060 kgEthiopia Commodity ExchangeMarch 2010September 2nd, 2010Ethiopia Commodity ExchangeNaNNaN8.678.678.588.428.338.429.3310.09.338.6788.420.0300NaN0.0September 2nd, 2011Ethiopia Commodity Exchangea176532400aebdc345cf3d870f84ed3ecab6249e61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24bm1570.01700.01635.0
9910Arabicadiamond enterprise plcEthiopiatulla coffee farmtulla coffee farm2014/15diamond enterprise plc1795-1850snnp/kaffa zone,gimboweredaDiamond Enterprise Plc5060 kgMETAD Agricultural Development plc2014March 30th, 2015Diamond Enterprise PlcOtherNatural / Dry8.088.588.508.507.678.4210.0010.010.008.588.250.100Green4.0March 29th, 2016METAD Agricultural Development plc309fcf77415a3661ae83e027f7e5f05dad786e4419fef5a731de2db57d16da10287413f5f99bc2ddm1795.01850.01822.5

Last rows

df_indexIDSpeciesOwnerCountry.of.OriginFarm.NameMillICO.NumberCompanyAltitudeRegionProducerNumber.of.BagsBag.WeightIn.Country.PartnerHarvest.YearGrading.DateOwner.1VarietyProcessing.MethodAromaFlavorAftertasteAcidityBodyBalanceUniformityClean.CupSweetnessCupper.PointsTotal.Cup.PointsMoistureCategory.One.DefectsQuakersColorCategory.Two.DefectsExpirationCertification.BodyCertification.AddressCertification.Contactunit_of_measurementaltitude_low_metersaltitude_high_metersaltitude_mean_meters
130213091302Arabicakurt kappeliMexicovariousf.i.e.c.h.0016-2847-0001globus coffee1000 meterssierra norte yajalon, chiapasvarious small producers2802 kgSpecialty Coffee Association2014May 5th, 2014Kurt KappeliTypicaWashed / Wet6.927.006.836.927.426.926.006.0010.006.7570.750.1200Green1.0May 5th, 2015Specialty Coffee Association36d0d00a3724338ba7937c52a378d085f2172daa0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660m1000.001000.001000.00
130313101303Arabicavolcafe ltda. - brasilBrazilNaNcopagNaNvolcafe ltda.NaNcerradoNaN30559 kgBrazil Specialty Coffee Association2017 / 2018October 27th, 2017Volcafe Ltda. - BrasilNaNNatural / Dry7.007.006.837.007.336.836.006.0010.006.6770.670.1101Green55.0October 27th, 2018Brazil Specialty Coffee Association3297cfa4c538e3dd03f72cc4082c54f7999e1f9d8900f0bf1d0b2bafe6807a73562c7677d57eb980mNaNNaNNaN
130413111304ArabicacadexsaHondurascerro buenocadexsa13-63-174cadexsa1450 msnmmarcalaOmar Acosta2751 kgInstituto Hondureño del Café2014May 15th, 2014CADEXSACatuaiWashed / Wet6.676.506.176.676.836.178.008.008.006.3369.330.100Green4.0May 15th, 2015Instituto Hondureño del Caféb4660a57e9f8cc613ae5b8f02bfce8634c763ab47f521ca403540f81ec99daec7da19c2788393880m1450.001450.001450.00
130513121305ArabicacadexsaHondurascerro buenocadexsa13-63-174cadexsa1450 msnmmarcalaOmar Acosta2751 kgInstituto Hondureño del Café2014May 15th, 2014CADEXSACatuaiWashed / Wet7.006.176.176.676.506.178.008.008.006.569.170.100Green3.0May 15th, 2015Instituto Hondureño del Caféb4660a57e9f8cc613ae5b8f02bfce8634c763ab47f521ca403540f81ec99daec7da19c2788393880m1450.001450.001450.00
130613131306ArabicacadexsaHondurascerro buenocadexsa13-63-174cadexsa1450 msnmmarcalaOmar Acosta2751 kgInstituto Hondureño del Café2014May 15th, 2014CADEXSACatuaiWashed / Wet7.006.336.176.506.676.178.008.008.006.3369.170.100Green4.0May 15th, 2015Instituto Hondureño del Caféb4660a57e9f8cc613ae5b8f02bfce8634c763ab47f521ca403540f81ec99daec7da19c2788393880m1450.001450.001450.00
130713141307Arabicajuan carlos garcia lopezMexicoel centenariola esperanza, municipio juchique de ferrer, veracruz1104328663terra mia900juchique de ferrerJUAN CARLOS GARCÍA LOPEZ121 kgAMECAFE2012September 17th, 2012JUAN CARLOS GARCIA LOPEZBourbonWashed / Wet7.086.836.257.427.256.7510.000.0010.006.7568.330.1100None20.0September 17th, 2013AMECAFE59e396ad6e22a1c22b248f958e1da2bd8af852720eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a7m900.00900.00900.00
130813151308Arabicamyriam kaplan-pasternakHaiti200 farmscoeb koperativ ekselsyo basen (350 members)NaNhaiti coffee~350mdepartment d'artibonite , haitiCOEB Koperativ Ekselsyo Basen12 kgSpecialty Coffee Association2012May 24th, 2012Myriam Kaplan-PasternakTypicaNatural / Dry6.756.586.426.677.086.679.336.006.006.4267.920.1480Blue-Green16.0May 24th, 2013Specialty Coffee Association36d0d00a3724338ba7937c52a378d085f2172daa0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660m350.00350.00350.00
130913161309Arabicaexportadora atlantic, s.a.Nicaraguafinca las maríasbeneficio atlantic condega017-053-0211/ 017-053-0212exportadora atlantic s.a1100jalapaTeófilo Narváez55069 kgInstituto Hondureño del Café2016June 6th, 2017Exportadora Atlantic, S.A.CaturraOther7.256.586.336.256.426.086.006.006.006.1763.080.1310Green5.0June 6th, 2018Instituto Hondureño del Caféb4660a57e9f8cc613ae5b8f02bfce8634c763ab47f521ca403540f81ec99daec7da19c2788393880m1100.001100.001100.00
131013171310Arabicajuan luis alvarado romeroGuatemalafinca el limonbeneficio serben11/853/165unicafe4650nuevo orienteWILLIAM ESTUARDO MARTINEZ PACHECO2751 kgAsociacion Nacional Del Café2012May 24th, 2012Juan Luis Alvarado RomeroCatuaiWashed / Wet7.506.676.677.677.336.678.001.331.336.6759.830.100Green4.0May 24th, 2013Asociacion Nacional Del Caféb1f20fe3a819fd6b2ee0eb8fdc3da256604f1e53724f04ad10ed31dbb9d260f0dfd221ba48be8a95ft1417.321417.321417.32
131113181312Arabicabismarck castroHonduraslos hicaquescigrah s.a de c.v.13-111-053cigrah s.a de c.v1400comayaguaReinerio Zepeda27569 kgInstituto Hondureño del Café2017April 28th, 2017Bismarck CastroCaturraNaN0.000.000.000.000.000.000.000.000.00000.1200Green2.0April 28th, 2018Instituto Hondureño del Caféb4660a57e9f8cc613ae5b8f02bfce8634c763ab47f521ca403540f81ec99daec7da19c2788393880m1400.001400.001400.00